Skip to main content
Version: 8.4.08.4

V7 to V8 Differences

SRSE Structural Differences

Here are the five main structural differences from SRSE in V7 to V8:

  1. Repeating groups are now formatted in JSON.

  2. Columns with type DOUBLE are now precise to 9 decimal places.

  3. Time, DateTime, and Timestamp columns now include microseconds. For example, the value for a DateTime column myDateTime would be in the format 2025-01-05 11:20:36.123456. Previously, we would have had two columns with the value of the first column being 2025-01-05 11:20:36 and then a second column named myDateTime_us had the microseconds 123456.

  4. Varying-length text fields are now represented with TINYTEXT and TEXT types. The TINYTEXT fields have a max size of 255 characters and the TEXT fields have a max size of 10,000 characters.

  5. We are now using Hexadecimal formatting for ParentNumber, ClOrdId, GroupingCode, and RiskGroupId fields. These have 16 Hex characters and each four characters are separated by a dash like: 0000-0000-0000-0000. The MariaDB type for these fields is CHAR(19).

V7 Deprecated Tables

Listed below are all deprecated tables in V7 that will either (a) not appear in V8 (highlighted in red) or (b) have been modified in V8 (highlighted in yellow):

V7 TableV8 TableNote
sranalytics.msglivesurfaceadj
Columns have been split between msgLiveSurfaceCurve and msgLiveAtmVol
sranalytics.msglivesurfacecomposite
N/A
Deprecated
sranalytics.msglivesurfacegrid
Renamed to msgLiveSurfaceFixedGrid
sranalytics.msglivesurfaceterm
Replaced with msgLiveSurfaceFixedGrid
sranalytics.msgoptionimpliedquote
N/A
Deprecated
sranalytics.msgoptionimpliedquoteadj
Renamed to msgLiveImpliedQuoteAdj
sranalytics.msgsrdiscretedividend
Replaced with msgGlobalDividends
srauction.msgsrauctionmarkup
Merged into msgAuctionPrint (now in SRTrade)
srauction.msgsrauctionresult
Merged into msgAuctionPrint (now in SRTrade)
srcontrol.msgaltaccountroute
N/A
Deprecated
srcontrol.msgclientfacilitationctrl
N/A
Deprecated
srcontrol.msgmarrestrictedlist
N/A
Deprecated
srcontrol.msgsrfutureriskcontrol
Merged into msgSrRiskControl
srcontrol.msgsrfutureriskrecord
Merged into msgSrRiskControl
srcontrol.msgsrriskrecord
Merged into msgSrRiskControl
srcontrol.msguserriskcontrol
Merged into msgSrRiskControl
srcontrol.msguserriskrecord
Merged into msgSrRiskControl
srcontrol.msgusersymriskcontrol
Merged into msgSrRiskControl
srcontrol.msgusersymriskrecord
Merged into msgSrRiskControl
srlive.msgoptionatmvolprobability
N/A
Deprecated
srlive.msgsrliquidityrequest
Merged into msgAuctionNotice (now in SRTrade)
srrisk.msgaccountclearingrecord
N/A
Deprecated
srrisk.msgaccountriskrecord
Renamed to msgAccountRiskRecordV5
srrisk.msgaccountriskrecordv4
Merged into msgAccountRiskRecordV5 (same as above)
srrisk.msgclearingexasrecord
N/A
Deprecated
srrisk.msgcorpactionrecord
N/A
Deprecated
srrisk.msgexerciseassignmentrecord
N/A
Deprecated
srrisk.msgexpirationriskrecord
Renamed to msgExpirationRiskRecordV5
srrisk.msgfutureclearingrecord
Merged into msgSODClearingRecordV5
srrisk.msgfuturehedgesummary
N/A
Deprecated
srrisk.msgfuturepositionrecord
Renamed to msgFuturePositionRecordV5
srrisk.msgfuturepositionrecordv4
Merged into msgFuturePositionRecordV5 (same as above)
srrisk.msgfuturerisksummary
Renamed to msgFutureRiskSummaryV5
srrisk.msgfuturerisksummaryv4
Merged into msgFutureRiskSummaryV5 (same as above)
srrisk.msgindustryriskrecord
Renamed to msgIndustryRiskRecordV5
srrisk.msgoptionclearingrecord
Merged into msgSODClearingRecordV5
srrisk.msgoptionpositionrecord
Renamed to msgOptionPositionRecordV5
srrisk.msgoptionpositionrecordv4
Merged into msgOptionPositionRecordV5 (same as above)
srrisk.msgproductrisksummaryv4
Renamed to msgProductRiskSummaryV5
srrisk.msgriskcubedetail
Renamed to msgRiskCubeDetailV5
srrisk.msgstockclearingrecord
Merged into to msgSODClearingRecordV5
srrisk.msgstockpositionrecord
Renamed to msgStockPositionRecordV5
srrisk.msgstockpositionrecordv4
Merged into msgStockPositionRecordV5 (same as above)
srrisk.msgsymbolhedgesummary
N/A
Deprecated
srrisk.msgsymbolriskdetail
Renamed to msgSymbolRiskDetailV5
srrisk.msgsymbolrisksummary
Renamed to msgSymbolRiskSummaryV5
srrisk.msgsymbolrisksummaryv4
Merged into msgSymbolRiskSummaryV5 (same as above)
srtrade.msgauctionstrategyordergateway
N/A
Deprecated
srtrade.msgsrauctionaccntresponse
N/A
Deprecated
srtrade.msgsrauctionstrategyorderSplit into four auto-responder strategies. See Auction Auto-Responders for more info.
srtrade.msgsrauctionstrategystateSplit into four auto-responder strategies. See Auction Auto-Responders for more info.
srtrade.msgoptorderreplacegateway
Merged into msgOptOrderGateway
srtrade.msgsrfutbrkrevent
Merged into msgSrParentBrkrEvent
srtrade.msgsrfutbrkrstate
Merged into msgSrParenBrkrState
srtrade.msgsroptbrkrevent
Merged into msgSrParentBrkrEvent
srtrade.msgsroptbrkrstate
Merged into msgSrParentBrkrState
srtrade.msgsrstkbrkrevent
Merged into msgSrParentBrkrEvent
srtrade.msgsrstkbrkrstate
Merged into msgSrParentBrkrState
srtrade.msgtradecubedetailMoved to srrisk.msgTradeCubeDetailV5